CODEWITHSUNDEEP
excelgoogle-sheetsexcel-formula
Rod Wright
Rod Wright

Reputation: 13

How do I return data when the condition of two statements are true?

I'm trying to get a data point to return but only if two statements are true.

Statement one: If Date of cell B32 (Sheet 2) = The Date of B2 (Sheet 1) Statement two: If Cell Name C30 (Sheet 2) = Cell Name C2 (Sheet 1) Then C32 (Sheet 2) would display the data point from D2 (Sheet 1)

So if these two conditions are met, then the cell would return the data point I wanted.

Also I'm not sure if I should be using B2/C2 of the whole columns of B/C in my formula. I'd like some input on that as well.

Photo 1: https://drive.google.com/open?id=0BwIeyMliU7Z4TmZ4N29VbGRrMnc

Photo 2: https://drive.google.com/open?id=0BwIeyMliU7Z4eS1iRHF4a1QxcTQ

Upvotes: 1

Views: 84

Answers (1)

Sangbok Lee
Sangbok Lee

Reputation: 2228

Try something like this. Sample sheet is here. You should search and study sumif, sumifs, countif, countifs, etc. Formula which ends with s can handle multiple conditions.

=sumifs(report!D:D, report!B:B, "="&$B32, report!C:C, "="&C$30)

Though, the structure of your sheets is not scalable.

Upvotes: 1

Related Questions